Tabela PerfContractServiceInvoice

Definicja tabeli PerfContractServiceInvoice

Name

PerfContractServiceInvoice

Code

PerfContractServiceInvoice

Comment

PL: informacje o fakturach sprawozdawanych przy swiadczeniu (niekoniecznie chemiotarapii)


Lista kolumn tabeli PerfContractServiceInvoice

Name

Code

PerfContractServiceInvoiceID

PerfContractServiceInvoiceID

ContractServicePerfID

ContractServicePerfID

TaxPayerID

TaxPayerID

InvoiceNumber

InvoiceNumber

InvoiceDT

InvoiceDT

PositionInInvoice

PositionInInvoice

Amount

Amount

Value

Value


Kolumna PerfContractServiceInvoiceID tabeli PerfContractServiceInvoice

Definicja kolumny PerfContractServiceInvoiceID tabeli PerfContractServiceInvoice

Name

PerfContractServiceInvoiceID

Code

PerfContractServiceInvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna ContractServicePerfID tabeli PerfContractServiceInvoice

Definicja kolumny ContractServicePerfID tabeli PerfContractServiceInvoice

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

powiazanie ze swiadczeniem


Kolumna TaxPayerID tabeli PerfContractServiceInvoice

Definicja kolumny TaxPayerID tabeli PerfContractServiceInvoice

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(13)

Mandatory

Yes

Comment

numer NIP kontrahenta który wystawil fakture


Kolumna InvoiceNumber tabeli PerfContractServiceInvoice

Definicja kolumny InvoiceNumber tabeli PerfContractServiceInvoice

Name

InvoiceNumber

Code

InvoiceNumber

Data Type

VARCHAR2(25)

Mandatory

Yes

Comment

numer faktury


Kolumna InvoiceDT tabeli PerfContractServiceInvoice

Definicja kolumny InvoiceDT tabeli PerfContractServiceInvoice

Name

InvoiceDT

Code

InvoiceDT

Data Type

DATE

Mandatory

Yes

Comment

data faktury (bez godzin-minut)


Kolumna PositionInInvoice tabeli PerfContractServiceInvoice

Definicja kolumny PositionInInvoice tabeli PerfContractServiceInvoice

Name

PositionInInvoice

Code

PositionInInvoice

Data Type

NUMBER(4)

Mandatory

Yes

Comment

numer pozycji na fakturze


Kolumna Amount tabeli PerfContractServiceInvoice

Definicja kolumny Amount tabeli PerfContractServiceInvoice

Name

Amount

Code

Amount

Data Type

NUMBER(14,5)

Mandatory

Yes

Comment

ilosc podanej substancji / leku


Kolumna Value tabeli PerfContractServiceInvoice

Definicja kolumny Value tabeli PerfContractServiceInvoice

Name

Value

Code

Value

Data Type

NUMBER(14,6)

Mandatory

Yes

Comment

wartosc produktu


Lista kluczy tabeli PerfContractServiceInvoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfContractServiceInvoice

Definicja klucza Identifier_1 tabeli PerfContractServiceInvoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment